A real-time concurrency control algorithm: Use of multiversion and precedence relationships

نویسندگان

  • Seok-Hee Hong
  • Myoung-Ho Kim
چکیده

This paper proposes a multiversion concurrency control algorithm for real-time databases. Based on a priority cognitive algorithm commonly used in real-time processing, the algorithm resolves data connicts among connict-ing transactions in favor of the urgent transactions, i.e., those with higher priority. Our algorithm is expected to minimize the transactions missing those deadlines and increase the degree of transaction concurrency by using precedence relationships and multiple versions. In the algorithm, a precedence relationship, which implies a serialization order among con-icting transactions, is utilized to resolve data connicts. By exploiting precedence relationships, our algorithm can avoid deadlocks, and dynamically determine the abortion of lower priority transactions depending on the likelihood of roll-backs and the amount of the work done by the low priority transaction.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Resolving Data Conflicts with Multiple Versions and Precedence Relationships in Real-Time Databases

We propose a multiversion concurrency control algorithm for real-time databases. Based on a priority cognitive algorithm commonly used in real-time processing, the proposed algorithm resolves data connicts among transactions in favor of the urgent transactions, i.e., those with higher priority. Our algorithm increases the degree of transaction concurrency while minimizing the transactions that ...

متن کامل

Analysis of Real-Time Multi version Concurrency Control Algorithms using Serialisability Graphs

57 ABSTRACT This paper analyses the correctness of Multiversion Concurrency Control(MVCC) algorithms that are commonly deployed in Realtime Databases. Database systems for real-time applications must satisfy timing constraints associated with transactions. Typically, a timing constraint is expressed in the form of a deadline and is represented as a priority to be used by schedulers. MVCC Algori...

متن کامل

Real-time Multiversion Repeatable Read Isolation Level

Concurrency control is the activity of synchronizing database operations by concurrently executing transactions on a shared database. We examine the problem of concurrency control when the database supports multiple versions of the data. Multiversion concurrency control is used in order to improve the level of achievable concurrency. The goal is to produce an execution that has the same effect ...

متن کامل

Real-time Optimistic Concurrency Control based on Transaction Finish Degree

Concurrency control is one of the main issues in the studies of real-time database systems. Optimistic concurrency control algorithms have the attractive properties of being non-blocking and deadlock-free. However, they have the problems of late conflict detection and transaction restarts. Although the number of transaction restarts is reduced by dynamic adjustment of serialization order in rea...

متن کامل

Multiversion Locking Protocol with Freezing for Secure Real-Time Database Systems

Database systems for real-time applications must satisfy timing constraints associated with transactions. Typically, a timing constraint is expressed in the form of a deadline and is represented as a priority to be used by schedulers. Recently, security has become another important issue in many real-time applications. In many systems, sensitive information is shared by multiple users with diff...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:
  • Journal of Systems Architecture

دوره 44  شماره 

صفحات  -

تاریخ انتشار 1997